﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace CI.Caja.DL
{
    public class DA_Utilitario
    {
        public SqlConnection getConnection()
        {
            try
            {
                //SqlConnection cnx = new SqlConnection(@"Server=.;Database=bdclinica;User Id=sa;Password=123456;");
                SqlConnection cnx = new SqlConnection(@"Data Source=SQL5005.Smarterasp.net;Initial Catalog=DB_9AE3CA_BDCLINICA;User Id=DB_9AE3CA_BDCLINICA_admin;Password=12345678;");
                //SqlConnection cnx = new SqlConnection(@"Data Source=.\\SqlExpress;Initial Catalog=BDCLINICA;Integrated Security=SSPI;");

                return cnx;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static string ObtenerConexion()
        {
            //return "Data Source=.;Initial Catalog=BDCLINICA;User Id=sa;Password=123456;";
            return "Data Source=SQL5005.Smarterasp.net;Initial Catalog=DB_9AE3CA_BDCLINICA;User Id=DB_9AE3CA_BDCLINICA_admin;Password=12345678;";
            //return "Data Source=.\\SqlExpress;Initial Catalog=BDCLINICA;Integrated Security=SSPI;";
            //return @"Data Source=LUISM\SQLEXPRESS2008R2;Initial Catalog=BDCLINICA;User Id=sa;Password=123456;";
        }
    }
}